2015-05-06 - 19746.100 - Spec - Create Analysis sources for Japan #BExQueriesforCrystalReportsAnalysisTool
SPECIFICATIONS
19746.100 - Create Analysis sources for Japan
Purpose
Need to create Analysis sources for Japan same as the copy of VMP_OPASA_Q002_MATERIAL & VIS_SHIP_Q002.
Admin Info
Purpose
|
Need to create Analysis sources for Japan.
|
Requested By
|
Mark Harris
|
Spec Created By
|
Naveen G
|
Spec Created Date
|
06/05/2015
|
Spec QA by
|
Uday Kumar P
|
Objects
|
ZIS_SHIP, ZIC_SHIP
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
04
|
2
|
Documentation
|
02
|
3
|
Development/ Config
|
24
|
4
|
Unit test in DEV
|
04
|
5
|
Unit test in QUA
|
04
|
6
|
Other activity
|
02
|
|
TOTAL
|
40
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1
|
Year & Display Parametrs should be diaplayed on top of the analysis prompt screen
|
Mark.G
|
06/12/2015
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Email From Mark G:
We need to have two queries pointed to the Japan cube, updated and checked for consistency. If possible please make a first pass at naming and display conventions, but I will validate this once the changes are available in DEV. It is important that these changes be ready to move into Production by next Thursday(June 11th). Please review and let me know if you have any questions or concerns.
Two BEx queries pointed to Japan cube, fields added and checked for consistency.
VIS_SHIP_Q002
- Add Product Hierarchy
- Add Period and Week
- Verify naming consistent with other sources
- Verify Text / Key display defaults consistent with other sources
- Verify Correct Order of Dimensions and Measures
VMP_OPASA_Q002_MATERIAL
- Verify naming consistent with other sources
- Verify Text / Key display defaults consistent with other sources
- Verify Correct Order of Dimensions and Measures
These changes will only be for Japan initially, however moving forward it is likely we will make these available for other regions.
In Scope:
Need to create BEx Queries only for Japan Region.
Out of Scope:
Other BEx Regional Queries.
Solution Summary
1. Need to add week to the shipped Cube & write necessary logic to populate the data.
2. Need to add week and posting period in the Shipped Infoset.
3. Need to create the BEx Queries same as the copy of VMP_OPASA_Q002_MATERIAL & VIS_SHIP_Q002 on Japan region.
4. Need to validate the data in BPD.
5. Need to collect all the changes into the transport request.
6. Need to reload the shipped cube once all the changes are moved to BPP(BW7.3 Production).
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
Check if the data for Week & period are populated correctly in the Shipped infoset.
|
Week & Period should be populated correctly.
|
2
|
Check if BEx Queries are validated against NEC standard checklist.
|
BEx Queries must be validated against the NEC standard checklist.
|
3
|
Check if all the BEx Queries are Collected successfully in to the transport request.
|
All the BEx Queries should be collected into the transport request.
|
Solution Details
1. Need to add week ZFISCWEK2 to the shipped Cube ZIC_SHIP & write necessary logic to populate the data.
2. Need to add week ZFISCWEK2, posting period 0FISCPER3 in the Shipped Infoset ZIS_SHIP.
3. Need to create the BEx Queries same as the copy of VMP_OPASA_Q002_MATERIAL & VIS_SHIP_Q002 on Japan region.
4. Need to validate the data in BPD & BPQ.
5. Need to collect all the changes into the transport request.
6. Need to reload the shipped cube once all the changes are moved to BPP(BW7.3 Production).
Issues
None